Default Behavior of Data Access Services

When planning your SequeLink configuration, you may find it helpful to know the definition of the default (or newly created) data access service on Linux/UNIX/Windows, and z/OS so that you can decide whether the default definition fits your needs. If it does not, you can change the values of the service's attributes. The attributes can be modified using one of the SequeLink Manager tools. For instructions on using the SequeLink Manager, refer to the SequeLink Administrator's Guide.

Default Behavior on Linux, UNIX, and Windows

This information pertains to Windows and UNIX environments.

The following sections define the default behavior of the default SequeLink data access service on Linux/UNIX/Windows, and provide the name of the attribute that dictates the behavior. All attribute names are shown in parentheses. The attributes that begin with DataSource (for example, DataSourceReadOnly) are the attributes that define a server data source. For complete information about service attributes, see the SequeLink Administrator's Guide.

Connection Model Default Behavior

The connection model default is ThreadPool. (ServiceConnectionModel)

The ThreadPool connection model default behavior is:

See "Planning Connection Models" for more information.

Event Handling Default Behavior

See "Planning Monitoring and Event Tracing" for more information.

Security Default Behavior for Users

The SequeLink Server accepts connections from all users, but only the users who can provide a valid DBMS user ID and password are allowed to access the database.

The database connection accepts all types of SQL statements. Once connected to the database, the database security system guarantees that the user can only perform actions that are allowed by the database administrator. Messages (except for user IDs and passwords) sent between the client and the server are sent as cleartext. The service attributes are set as follows: 

ServiceAuthMethods=anonymous 
ServiceUser=everyone
DataSourceLogonMethod=DBMSLogon(UID,PWD)
DataSourceReadOnly=No
ServiceEncryptionAlgorithm=none

See "Planning Security" for more information.

Refer to the SequeLink Administrator's Guide for complete information about configuring SequeLink security.

Security Default Behavior for Administrators

Only the person who logs on using the administrator ID entered when the SequeLink Server software was installed is allowed to manage the SequeLink environment. The SequeLink Server Setup prompts for the SequeLink administrator's user ID when you install the SequeLink Server. 

ServiceAdminAuthMethods=OSlogon(UID,PWD)
ServiceAdministrator=User_ID

NOTE: On Windows, the SequeLink administrator must have administrator rights.

See "Planning Security" for more information.

Refer to the SequeLink Administrator's Guide for complete information about configuring SequeLink security.

Debug Default Behavior

Debugging is disabled. ("ServiceDebugLogLevel" and "ServiceDebugLogPath")

Refer to the SequeLink Troubleshooting Guide and Reference for complete information about debugging.

General Service Default Behavior

General Data Source Default Behavior

Internationalization Default Behavior

The SequeLink administrator defines when SequeLink will support international code pages by selecting a service template with enhanced code page support. Support for international code pages is influenced by a combination of platform- and database-specific attributes.

When using the standard service template, SequeLink supports ASCII/EBCDIC transliteration for ODBC and ADO Clients. For JDBC and .NET Clients, SequeLink supports ASCII/EBCDIC conversion to UTF-16. The standard service template can also be used when the database code page maps to the client application code page. (ServiceCodePage=Default)

The standard service template can also be used when the SequeLink Client transliterates character data from the code page that the SequeLink service is using to the code page of the client application or system. (ServiceCodePage=OS)

When using the service template with enhanced code page support, SequeLink transliterates between the database code page and the application code page. See the default behavior section for each database for more information. (ServiceCodePage=Database)

DB2 Service Default Behavior

Informix Service Default Behavior

Microsoft SQL Server Service Default Behavior

Oracle Service Default Behavior

Sybase Service Default Behavior

ODBC Socket Service Default Behavior

JDBC Socket Service Default Behavior

Default Behavior on z/OS

The following sections define the default behavior of a SequeLink data access service on z/OS and provide the name of the attribute that dictates the behavior in parentheses. The attributes that begin with DataSource (for example, DataSourceReadOnly) are the attributes that define a server data source. For complete information about service attributes, refer to the SequeLink Administrator's Guide.

Connection Model Default Behavior

The ThreadPool connection model is the default. (ServiceConnectionModel)

The ThreadPool connection model default behavior is:

See "Planning Connection Models" for more information.

Event Handling Default Behavior

The size of the event trace file is 1000000 bytes. ("ServiceEventTraceSize")

See "Planning Monitoring and Event Tracing" for more information.

Security Default Behavior for Users

The SequeLink Server accepts connections from all users. However, only users who can provide a valid operating system user ID and password are allowed to access the database. If the RACF TERMINAL class is not activated, the terminal ID is not verified.

The database connection accepts all types of SQL statements. Once connected to the database, the database security system guarantees that the user can only perform actions that are allowed by the database administrator. Messages (except for user IDs and passwords) sent between the client and the server are sent as cleartext. The service attributes are set as follows: 

MVSServiceAuthorizationEnable=FALSE
ServiceAuthMethods=OSLogon(UID,PWD,NWPD)
DataSourceLogonMethod=OSIntegrated
DataSourceReadOnly=No
ServiceEncryptionAlgorithm=none

See "Planning Security" for more information.

Refer to the SequeLink Administrator's Guide for complete information about configuring SequeLink security.

Security Default Behavior for Administrators

The SequeLink Server accepts connections from all users. Only users who can provide a valid operating system user ID and password are allowed to access the SequeLink Agent service, which means they can manage the SequeLink environment. If the RACF TERMINAL class is not activated, the terminal ID is not verified. The service attributes are set as follows: 

MVSServiceAuthorizationEnable=FALSE
ServiceAdminAuthMethods=OSLogon(UID,PWD)

See "Planning Security" for more information.

Refer to the SequeLink Administrator's Guide for complete information about configuring SequeLink security.

Internationalization Default Behavior

Because the SequeLink Server for DB2 for z/OS is a Unicode service, no configuration is required. The ServiceCodePage attribute is defined by default and cannot be changed in the SequeLink Manager or Command Line interface.

Debug Default Behavior

Debugging is not enabled. ("ServiceDebugLogLevel" and "ServiceDebugLogPath")

Refer to the SequeLink Troubleshooting Guide and Reference for complete information about debugging.

General Service Default Behavior

General Data Source Default Behavior